Skip to main content

PivotFieldSubtotals

Subtotal pivot field types (functions for subtotals).

Type

Object

Properties

NameTypeDescription
SumbooleanSpecififes whether the SUM function will be used.
CountbooleanSpecififes whether the COUNTA function will be used.
AveragebooleanSpecififes whether the AVERAGE function will be used.
MaxbooleanSpecififes whether the MAX function will be used.
MinbooleanSpecififes whether the MIN function will be used.
ProductbooleanSpecififes whether the PRODUCT function will be used.
CountNumbersbooleanSpecififes whether the COUNT function will be used.
StdDevbooleanSpecififes whether the STDEV function will be used.
StdDevPbooleanSpecififes whether the STDEV.P function will be used.
VarbooleanSpecififes whether the VAR function will be used.
VarPbooleanSpecififes whether the VAR.P function will be used.